**Make a simple BEA country concordance
   *Easy to add regions, etc as need from other make_bea_conc.do program.

cd ""  /* PROJECT ROOT FOLDER */
global data "data"
global input "input"


clear
set obs 1000
gen countrycode=_n


ge country=""			
replace country="Afghanistan"  if countrycode==600
replace country="Albania"  if countrycode==350
replace country="Algeria"  if countrycode==400
replace country="Andorra"  if countrycode==300
replace country="Angola"  if countrycode==401
replace country="Anguilla"  if countrycode==272
replace country="Antigua and Barbuda"  if countrycode==273
replace country="Argentina"  if countrycode==200
replace country="Armenia"  if countrycode==334
replace country="Aruba"  if countrycode==274
replace country="UK Islands Atlantic (Africa)"  if countrycode==455
replace country="Australia"  if countrycode==601
replace country="Australia"  if countrycode==601
replace country="Austria"  if countrycode==301
replace country="Azerbaijan"  if countrycode==335
replace country="Portugal"  if countrycode==321
replace country="Bahamas"  if countrycode==250
replace country="Bahrain"  if countrycode==501
replace country="Bangladesh"  if countrycode==631
replace country="Barbados"  if countrycode==251
replace country="Belarus"  if countrycode==336
replace country="Belgium"  if countrycode==302
replace country="Belize"  if countrycode==254
replace country="Benin"  if countrycode==409
replace country="Bermuda"  if countrycode==252
replace country="Bhutan"  if countrycode==602
replace country="Bolivia"  if countrycode==201
replace country="Netherlands Islands- Caribbean "  if countrycode==277
replace country="Japan"  if countrycode==614
replace country="Bosnia and Herzegovina"  if countrycode==358
replace country="Botswana"  if countrycode==402
replace country="Norway"  if countrycode==320
replace country="Brazil"  if countrycode==202
replace country="UK Islands Caribbean"  if countrycode==266
replace country="UK Islands Caribbean"  if countrycode==266
replace country="Brunei"  if countrycode==603
replace country="Bulgaria"  if countrycode==351
replace country="Burkina Faso"  if countrycode==447
replace country="Burma"  if countrycode==606
replace country="Burundi"  if countrycode==403
replace country="Angola"  if countrycode==401
replace country="Cabo Verde"  if countrycode==450
replace country="Cambodia"  if countrycode==607
replace country="Cameroon"  if countrycode==404
replace country="Canada"  if countrycode==100
replace country="Spain"  if countrycode==323
replace country="Kiribati"  if countrycode==655
replace country="UK Islands Caribbean"  if countrycode==266
replace country="Central African Republic"  if countrycode==405
replace country="Chad"  if countrycode==406
replace country="United Kingdom"  if countrycode==327
replace country="Chile"  if countrycode==203
replace country="China"  if countrycode==650
replace country="Kiribati"  if countrycode==655
replace country="French Islands Pacific"  if countrycode==610
replace country="Australia"  if countrycode==601
replace country="Colombia"  if countrycode==204
replace country="Comoros"  if countrycode==456
replace country="Congo, Democratic Republic of"  if countrycode==408
replace country="Congo, Republic of"  if countrycode==407
replace country="New Zealand"  if countrycode==620
replace country="Australia"  if countrycode==601
replace country="Costa Rica"  if countrycode==205
replace country="Cote d'Ivoire"  if countrycode==417
replace country="Croatia"  if countrycode==359
replace country="Cuba"  if countrycode==206
replace country="Curacao"  if countrycode==275
replace country="Cyprus"  if countrycode==304
replace country="Czech Republic"  if countrycode==364
replace country="Denmark"  if countrycode==305
replace country="Djibouti"  if countrycode==412
replace country="Dominica"  if countrycode==269
replace country="Dominican Republic"  if countrycode==207
replace country="UK Islands Atlantic"  if countrycode==268
replace country="Ecuador"  if countrycode==208
replace country="Egypt"  if countrycode==410
replace country="El Salvador"  if countrycode==209
replace country="United Kingdom"  if countrycode==327
replace country="Equatorial Guinea"  if countrycode==438
replace country="Eritrea"  if countrycode==457
replace country="Estonia"  if countrycode==331
replace country="Ethiopia"  if countrycode==411
replace country="French Islands Indian Ocean"  if countrycode==609
replace country="UK Islands Atlantic"  if countrycode==268
replace country="Denmark"  if countrycode==305
replace country="Fiji"  if countrycode==632
replace country="Finland"  if countrycode==306
replace country="French Islands Caribbean"  if countrycode==255
replace country="France"  if countrycode==307
replace country="French Islands Caribbean"  if countrycode==255
replace country="French Guiana"  if countrycode==256
replace country="French Islands Caribbean"  if countrycode==255
replace country="French Islands Indian Ocean"  if countrycode==609
replace country="French Islands Pacific"  if countrycode==610
replace country="French Islands Pacific"  if countrycode==610
replace country="French Islands Indian Ocean"  if countrycode==609
replace country="Gabon"  if countrycode==413
replace country="Gambia"  if countrycode==414
replace country="Israel"  if countrycode==504
replace country="Georgia"  if countrycode==337
replace country="Germany"  if countrycode==308
replace country="Ghana"  if countrycode==415
replace country="Gibraltar"  if countrycode==309
replace country="United Kingdom"  if countrycode==327
replace country="Greece"  if countrycode==310
replace country="Greenland"  if countrycode==311
replace country="Grenada"  if countrycode==265
replace country="French Islands Caribbean"  if countrycode==255
replace country="Guatemala"  if countrycode==210
replace country="Guernsey"  if countrycode==327
replace country="Guinea"  if countrycode==416
replace country="Guinea-Bissau"  if countrycode==430
replace country="Guyana"  if countrycode==257
replace country="Haiti"  if countrycode==211
replace country="Australia"  if countrycode==601
replace country="Honduras"  if countrycode==212
replace country="Hong Kong"  if countrycode==611
replace country="Hungary"  if countrycode==354
replace country="Iceland"  if countrycode==312
replace country="India"  if countrycode==612
replace country="Indonesia"  if countrycode==613
replace country="Iran"  if countrycode==502
replace country="Iraq"  if countrycode==503
replace country="Ireland"  if countrycode==313
replace country="United Kingdom"  if countrycode==327
replace country="Israel"  if countrycode==504
replace country="Italy"  if countrycode==314
replace country="Jamaica"  if countrycode==258
replace country="Norway"  if countrycode==320
replace country="Japan"  if countrycode==614
replace country="United Kingdom"  if countrycode==327
replace country="Jordan"  if countrycode==505
replace country="French Islands Indian Ocean"  if countrycode==609
replace country="Kazakhstan"  if countrycode==338
replace country="Kenya"  if countrycode==418
replace country="Kiribati"  if countrycode==655
replace country="Korea, Republic of"  if countrycode==626
replace country="Kosovo"  if countrycode==366
replace country="Kuwait"  if countrycode==506
replace country="Kyrgyzstan"  if countrycode==339
replace country="Laos"  if countrycode==615
replace country="Latvia"  if countrycode==332
replace country="Lebanon"  if countrycode==507
replace country="Lesotho"  if countrycode==419
replace country="Liberia"  if countrycode==420
replace country="Libya"  if countrycode==421
replace country="Liechtenstein"  if countrycode==315
replace country="Lithuania"  if countrycode==333
replace country="Luxembourg"  if countrycode==316
replace country="Macau"  if countrycode==616
replace country="Macedonia"  if countrycode==360
replace country="Madagascar"  if countrycode==422
replace country="Portugal"  if countrycode==321
replace country="Malawi"  if countrycode==423
replace country="Malaysia"  if countrycode==617
replace country="Maldives"  if countrycode==633
replace country="Mali"  if countrycode==424
replace country="Malta"  if countrycode==317
replace country="Marshall Islands, Republic of"  if countrycode==658
replace country="French Islands Caribbean"  if countrycode==255
replace country="Mauritania"  if countrycode==425
replace country="Mauritius"  if countrycode==453
replace country="Comoros"  if countrycode==456
replace country="Mexico"  if countrycode==213
replace country="Micronesia, Federated States of"  if countrycode==657
replace country="Moldova"  if countrycode==340
replace country="Monaco"  if countrycode==318
replace country="Mongolia"  if countrycode==651
replace country="Montenegro"  if countrycode==361
replace country="UK Islands Caribbean"  if countrycode==266
replace country="Morocco"  if countrycode==426
replace country="Mozambique"  if countrycode==427
replace country="Namibia"  if countrycode==437
replace country="Nauru"  if countrycode==635
replace country="Nepal"  if countrycode==618
replace country="Netherlands"  if countrycode==319
replace country="Netherlands Antilles"  if countrycode==259
replace country="Netherlands Islands- Caribbean "  if countrycode==277
replace country="French Islands Pacific"  if countrycode==610
replace country="New Zealand"  if countrycode==620
replace country="Nicaragua"  if countrycode==214
replace country="Niger"  if countrycode==428
replace country="Nigeria"  if countrycode==429
replace country="New Zealand"  if countrycode==620
replace country="Australia"  if countrycode==601
replace country="North Korea"  if countrycode==652
replace country="United Kingdom"  if countrycode==327
replace country="Norway"  if countrycode==320
replace country="Oman"  if countrycode==508
replace country="Pakistan"  if countrycode==622
replace country="Palau"  if countrycode==659
replace country="Panama"  if countrycode==215
replace country="Papua New Guinea"  if countrycode==619
replace country="China"  if countrycode==650
replace country="Paraguay"  if countrycode==216
replace country="Peru"  if countrycode==217
replace country="Philippines"  if countrycode==623
replace country="UK Islands Pacific"  if countrycode==604
replace country="Poland"  if countrycode==355
replace country="Portugal"  if countrycode==321
replace country="Colombia"  if countrycode==204
replace country="Qatar"  if countrycode==510
replace country="Antigua and Barbuda"  if countrycode==273
replace country="French Islands Indian Ocean"  if countrycode==609
replace country="Romania"  if countrycode==356
replace country="Russia"  if countrycode==341
replace country="Rwanda"  if countrycode==432
replace country="Netherlands Islands- Caribbean "  if countrycode==277
replace country="Samoa"  if countrycode==637
replace country="San Marino"  if countrycode==322
replace country="Sao Tome and Principe"  if countrycode==451
replace country="Italy"  if countrycode==314
replace country="Saudi Arabia"  if countrycode==511
replace country="United Kingdom"  if countrycode==327
replace country="Senegal"  if countrycode==433
replace country="Serbia"  if countrycode==362
replace country="Seychelles"  if countrycode==454
replace country="United Kingdom"  if countrycode==327
replace country="Italy"  if countrycode==314
replace country="Sierra Leone"  if countrycode==434
replace country="Singapore"  if countrycode==625
replace country="Sint Maarten"  if countrycode==276
replace country="Slovakia"  if countrycode==365
replace country="Slovenia"  if countrycode==363
replace country="Solomon Islands"  if countrycode==654
replace country="Somalia"  if countrycode==435
replace country="South Africa"  if countrycode==436
replace country="UK Islands Atlantic"  if countrycode==268
replace country="UK Islands Atlantic"  if countrycode==268
replace country="UK Islands Atlantic"  if countrycode==268
replace country="South Sudan"  if countrycode==458
replace country="Spain"  if countrycode==323
replace country="China"  if countrycode==650
replace country="Sri Lanka"  if countrycode==608
replace country="French Islands Caribbean"  if countrycode==255
replace country="Netherlands Islands- Caribbean "  if countrycode==277
replace country="UK Islands Atlantic (Africa)"  if countrycode==455
replace country="St. Kitts and Nevis"  if countrycode==267
replace country="St. Lucia"  if countrycode==270
replace country="St. Pierre and Miquelon"  if countrycode==263
replace country="St. Vincent and the Grenadines"  if countrycode==271
replace country="Sudan"  if countrycode==441
replace country="Suriname"  if countrycode==260
replace country="Norway"  if countrycode==320
replace country="Swaziland"  if countrycode==442
replace country="Sweden"  if countrycode==324
replace country="Switzerland"  if countrycode==325
replace country="Syria"  if countrycode==512
replace country="Taiwan"  if countrycode==628
replace country="Tajikistan"  if countrycode==342
replace country="Tanzania"  if countrycode==443
replace country="Thailand"  if countrycode==629
replace country="Timor-Leste"  if countrycode==660
replace country="Togo"  if countrycode==444
replace country="New Zealand"  if countrycode==620
replace country="Tonga"  if countrycode==638
replace country="UK Islands Caribbean"  if countrycode==266
replace country="Trinidad and Tobago"  if countrycode==261
replace country="French Islands Indian Ocean"  if countrycode==609
replace country="Tunisia"  if countrycode==445
replace country="Turkey"  if countrycode==326
replace country="Turkmenistan"  if countrycode==343
replace country="UK Islands Caribbean"  if countrycode==266
replace country="Tuvalu"  if countrycode==656
replace country="Uganda"  if countrycode==446
replace country="UK Islands Atlantic"  if countrycode==268
replace country="UK Islands Atlantic (Africa)"  if countrycode==455
replace country="UK Islands Caribbean"  if countrycode==266
replace country="UK Islands Indian Ocean"  if countrycode==605
replace country="UK Islands Pacific"  if countrycode==604
replace country="Ukraine"  if countrycode==344
replace country="United Arab Emirates"  if countrycode==513
replace country="United Kingdom"  if countrycode==327
replace country="United States of America"  if countrycode==199
replace country="Uruguay"  if countrycode==218
replace country="Uzbekistan"  if countrycode==345
replace country="Vanuatu"  if countrycode==636
replace country="Vatican City"  if countrycode==330
replace country="Venezuela"  if countrycode==219
replace country="Vietnam"  if countrycode==653
replace country="United Kingdom"  if countrycode==327
replace country="French Islands Pacific"  if countrycode==610
replace country="Israel"  if countrycode==504
replace country="UK Islands Atlantic"  if countrycode==268
replace country="Western Sahara"  if countrycode==440
replace country="Yemen"  if countrycode==514
replace country="Yemen (Aden)"  if countrycode==500
replace country="Yugoslavia"  if countrycode==328
replace country="Zambia"  if countrycode==448
replace country="Zimbabwe"  if countrycode==431

drop if country==""

save $data/bea_countries.dta, replace
